I wrote this little app to help a programmer who wanted to create a database but didn't have a DB program (like Access)
1) You can open an existing database file (Access version 2.0 or earlier) and examine the tables and queries, including fields, field data types, field values and SQL statements.
2) You can append tables to a database or fields to a table.
3) You can create a new database (Access 2.0) and add its tables and fields.
The code is commented, and should give a fairly good idea how to use VB's data access objects to create, view and manipulate database files.
The ZIP file contains a VB3 form and its executable.
There's no error trapping (this was a one night project) so don't do something foolish like give a table the name of an already existing table, or set the size of a text field to a negative number, etc.
Note: This code is intended specifically for VB 3 Pro. It will NOT work with VB 3 Standard Edition because the Standard Edition does not fully support VB's data access features. With modifications, it can be made to work with later versions of VB Pro. You will need to have the Common Dialog control loaded prior to opening the form file or you will get an error.
